Tabela Vaccine

Definicja tabeli Vaccine

Name

Vaccine

Code

Vaccine

Comment

Szczepionka


Lista kolumn tabeli Vaccine

Name

Code

VaccineID

VaccineID

AgeUnitID

AgeUnitID

VaccineTypeID

VaccineTypeID

VaccineScheduleVersionID

VaccineScheduleVersionID

VaccineKindID

VaccineKindID

Active

Active

Code

Code

Name

Name

AgeFrom

AgeFrom

AgeTo

AgeTo

DoseNumber

DoseNumber

DoseCount

DoseCount

RemindDose

RemindDose

VaccineKinds

VaccineKinds

AdministrationMethods

AdministrationMethods

AgeMainDescr

AgeMainDescr

AgeDetailDescr

AgeDetailDescr

RecommendedForPatients

RecommendedForPatients

Description

Description


Kolumna VaccineID tabeli Vaccine

Definicja kolumny VaccineID tabeli Vaccine

Name

VaccineID

Code

VaccineID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna AgeUnitID tabeli Vaccine

Definicja kolumny AgeUnitID tabeli Vaccine

Name

AgeUnitID

Code

AgeUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VaccineTypeID tabeli Vaccine

Definicja kolumny VaccineTypeID tabeli Vaccine

Name

VaccineTypeID

Code

VaccineTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna VaccineScheduleVersionID tabeli Vaccine

Definicja kolumny VaccineScheduleVersionID tabeli Vaccine

Name

VaccineScheduleVersionID

Code

VaccineScheduleVersionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna VaccineKindID tabeli Vaccine

Definicja kolumny VaccineKindID tabeli Vaccine

Name

VaccineKindID

Code

VaccineKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID rodzaju szczepienia


Kolumna Active tabeli Vaccine

Definicja kolumny Active tabeli Vaccine

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Kolumna Code tabeli Vaccine

Definicja kolumny Code tabeli Vaccine

Name

Code

Code

Code

Data Type

VARCHAR2(32)

Mandatory

No

Comment

kod szczepionki


Kolumna Name tabeli Vaccine

Definicja kolumny Name tabeli Vaccine

Name

Name

Code

Name

Data Type

VARCHAR2(100)

Mandatory

Yes

Comment

nazwa


Kolumna AgeFrom tabeli Vaccine

Definicja kolumny AgeFrom tabeli Vaccine

Name

AgeFrom

Code

AgeFrom

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna AgeTo tabeli Vaccine

Definicja kolumny AgeTo tabeli Vaccine

Name

AgeTo

Code

AgeTo

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna DoseNumber tabeli Vaccine

Definicja kolumny DoseNumber tabeli Vaccine

Name

DoseNumber

Code

DoseNumber

Data Type

NUMBER(5)

Mandatory

No

Comment

numer dawki


Kolumna DoseCount tabeli Vaccine

Definicja kolumny DoseCount tabeli Vaccine

Name

DoseCount

Code

DoseCount

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Kolumna RemindDose tabeli Vaccine

Definicja kolumny RemindDose tabeli Vaccine

Name

RemindDose

Code

RemindDose

Data Type

NUMBER(1)

Mandatory

Yes

Comment

dawka przypominajaca


Kolumna VaccineKinds tabeli Vaccine

Definicja kolumny VaccineKinds tabeli Vaccine

Name

VaccineKinds

Code

VaccineKinds

Data Type

VARCHAR2(255)

Mandatory

No

Comment

rodzaje szczepionki


Kolumna AdministrationMethods tabeli Vaccine

Definicja kolumny AdministrationMethods tabeli Vaccine

Name

AdministrationMethods

Code

AdministrationMethods

Data Type

VARCHAR2(255)

Mandatory

No

Comment

metody podania


Kolumna AgeMainDescr tabeli Vaccine

Definicja kolumny AgeMainDescr tabeli Vaccine

Name

AgeMainDescr

Code

AgeMainDescr

Data Type

VARCHAR2(32)

Mandatory

No

Comment

wiek pacjenta opisowo


Kolumna AgeDetailDescr tabeli Vaccine

Definicja kolumny AgeDetailDescr tabeli Vaccine

Name

AgeDetailDescr

Code

AgeDetailDescr

Data Type

VARCHAR2(255)

Mandatory

No

Comment

wiek pacjenta szczególy


Kolumna RecommendedForPatients tabeli Vaccine

Definicja kolumny RecommendedForPatients tabeli Vaccine

Name

RecommendedForPatients

Code

RecommendedForPatients

Data Type

CLOB

Mandatory

No

Comment

Szczególnie zalecane osobom


Kolumna Description tabeli Vaccine

Definicja kolumny Description tabeli Vaccine

Name

Description

Code

Description

Data Type

CLOB

Mandatory

No

Comment

uwagi


Lista kluczy tabeli Vaccine

Name

Code

Primary

PK_Vaccine

PK_Vaccine

X


Klucz PK_Vaccine tabeli Vaccine

Definicja klucza PK_Vaccine tabeli Vaccine

Name

PK_Vaccine

Code

PK_Vaccine

Primary

Yes

Comment